-- @owner: cloudsbreak
-- @date: 2025/06/30
-- @testpoint:使用抽象数据类型--使用type构造函数

--setup
@conn  PrimaryDbAmode;

--step1:
create or replace type person_object as object(
atri_pid number,
atri_name varchar2(10),
atri_sex varchar2(10),
constructor function person_base(patri_pid number) return self as result
);

create or replace type person_object as object(
atri_pid number,
atri_name varchar2(10),
atri_sex varchar2(10),
constructor function person_object(patri_pid number) return self as result
);
--teardown:环境清理
drop type person_object;

